2013-04-16 - 5910.200 - Rel Notes - Contracts - Release 033 #BIReleases2013
Release Notes:
5910.200 - Contracts - OSA920
Admin Info
Purpose
|
Including Contract Information in OSA920 report
|
Release No
|
033
|
Submitted
|
04-16-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Mallareddy D
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
OSA920 - Open Orders by Sales Org, Sales Manager, Style, License, Sales Rep and Account.
BEx Query
ZMP_OPASA_Q033
NEC Crystal Reports Standards Check
1. OSA920 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA920 NEC CR checklist has been sent to NEC and also attached here for reference:
OSA920 NEC CR Standard Check List.xlsx
Dynamic Group 1:
Test Conducted
Dynamic Grouping Parameter(1) and Group Name: Sales Org > Sales Manager > Style > License > Sales Rep > Customer
Summary Level Check
Test Conducted
Group: Sales Orgs - 5th & Ocean Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,280,893
|
1,280,893
|
Pass
|
2
|
Sales Org Currency
|
12,081,338
|
12,081,338.44
|
Pass
|
3
|
Corporate Currency
|
12,081,338
|
12,081,338.44
|
Pass
|
Group: Sales Orgs - EMEA Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,868,158
|
1,868,158
|
Pass
|
2
|
Sales Org Currency
|
15,487,662
|
15,487,638.14
|
Pass
|
3
|
Corporate Currency
|
23,465,958
|
23,465,952.36
|
Pass
|
Note: For EMEA Sales, Sales Org Currency and Corporate Currency are not matching with BEx Query values. The difference is £24 and $6 respectively considered as successfully validated.
Second Level Check
Test Conducted
Group: APAC Sales > Andrew Wood
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
4,870
|
4,870
|
Pass
|
2
|
Sales Org Currency
|
337,144
|
337,144.29
|
Pass
|
3
|
Corporate Currency
|
43,429
|
43,429.08
|
Pass
|
Group: German Sales > Markus Fink
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
2,583
|
2,583
|
Pass
|
2
|
Sales Org Currency
|
27,385
|
27,385.05
|
Pass
|
3
|
Corporate Currency
|
35,050
|
35,050.13
|
Pass
|
Third Level Check
Test Conducted
Group: Australia > Daniel Broderick > 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
379
|
379
|
Pass
|
2
|
Sales Org Currency
|
2,820
|
2,819.72
|
Pass
|
3
|
Corporate Currency
|
2,940
|
2,939.84
|
Pass
|
Group : EMES Sales > Cristiana Zaccarelli > 1920
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
18
|
18
|
Pass
|
2
|
Sales Org Currency
|
297
|
297.29
|
Pass
|
3
|
Corporate Currency
|
450
|
450.40
|
Pass
|
Fourth Level Check
Test Conducted
Group: Mexico Sales > David Perez > 3930 > MEXICAN BASEBALL LEAGUE
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,403
|
1,403
|
Pass
|
2
|
Sales Org Currency
|
157,147
|
157,147.00
|
Pass
|
3
|
Corporate Currency
|
12,729
|
12,728.91
|
Pass
|
Group: APAC Sales > Andrew Wood > 3930 > TRANSFORMERS - HASBRO
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
12
|
12
|
Pass
|
2
|
Sales Org Currency
|
327
|
326.98
|
Pass
|
3
|
Corporate Currency
|
42
|
42.12
|
Pass
|
Fifth Level Check
Test Conducted
Group: Australia Sales > Daniel Broderick > 5950 > AUSTRALIAN FOOTBALL LEAGUE > David Biwer
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
44
|
44
|
Pass
|
2
|
Sales Org Currency
|
247
|
246.96
|
Pass
|
3
|
Corporate Currency
|
258
|
257.48
|
Pass
|
Group: Canada Sales >Bill Adams > 3930 > NON LICENSED > House
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
413
|
413
|
Pass
|
2
|
Sales Org Currency
|
1,304
|
1,304.02
|
Pass
|
3
|
Corporate Currency
|
1,283
|
1,283.16
|
Pass
|
Sixth Level Check
Test Conducted
Group: German Sales > Markus Fink > 3930 > MLB PROPERTIES > Jan Henning > GALERIA KAUFHOF GHBH
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,338
|
1,338
|
Pass
|
2
|
Sales Org Currency
|
11,538
|
11,538.40
|
Pass
|
3
|
Corporate Currency
|
14,768
|
14,768.00
|
Pass
|
Group: 5th & Ocean Sales > Al Derago > FLEECE TOPS > MLB PROPERTIES > House > MAST INDUSTRIES INC
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
8,573
|
8,573
|
Pass
|
2
|
Sales Org Currency
|
146,084
|
146,083.92
|
Pass
|
3
|
Corporate Currency
|
146,084
|
146,083.92
|
Pass
|
Dynamic Group 2:
Test Conducted
Dynamic Grouping Parameter(2) and Group Name: Sales Org > Sales Mangaer > Sales Rep > Style > License > Customer
Summary Level Check
Test Conducted
Group: Sales Orgs - APAC Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
65,487
|
65,487
|
Pass
|
2
|
Sales Org Currency
|
7,010,721
|
7,010,720.53
|
Pass
|
3
|
Corporate Currency
|
903,083
|
903,082.60
|
Pass
|
Group: Sales Orgs - Mexico sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
291,403
|
291,403
|
Pass
|
2
|
Sales Org Currency
|
62,838,374
|
62,838,373.86
|
Pass
|
3
|
Corporate Currency
|
5,089,908
|
5,089,908.28
|
Pass
|
Second Level Check
Test Conducted
Group: Australia Sales > David Biwer
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
33,292
|
33,292
|
Pass
|
2
|
Sales Org Currency
|
653,592
|
653,592.38
|
Pass
|
3
|
Corporate Currency
|
681,435
|
681,435.42
|
Pass
|
Group: NEC Korea Sales > Yoo Kang
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
23,774
|
23,774
|
Pass
|
2
|
Sales Org Currency
|
455,054,104
|
455,054,104
|
Pass
|
3
|
Corporate Currency
|
409,549
|
409,548.69
|
Pass
|
Third Level Check
Test Conducted
Group: German Sales > Markus Fink > Jan Henning
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
2,583
|
2,583
|
Pass
|
2
|
Sales Org Currency
|
27,385
|
27,385.05
|
Pass
|
3
|
Corporate Currency
|
35,050
|
35,050.13
|
Pass
|
Group: Latin America Sales > Jim Grundtisch > Amado Gonzalez
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
770
|
770
|
Pass
|
2
|
Sales Org Currency
|
11,703
|
11,702.72
|
Pass
|
3
|
Corporate Currency
|
11,703
|
11,702.72
|
Pass
|
Fourth Level Check
Test Conducted
Group: Mexico Sales > David Perez > House > 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
3
|
3
|
Pass
|
2
|
Sales Org Currency
|
694
|
693.93
|
Pass
|
3
|
Corporate Currency
|
56
|
56.21
|
Pass
|
Group: EMEA Sales > Giovanni Mantella > Ingesba SL > 4940
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
8
|
8
|
Pass
|
2
|
Sales Org Currency
|
70
|
69.69
|
Pass
|
3
|
Corporate Currency
|
106
|
105.60
|
Pass
|
Fifth Level Check
Test Conducted
Group: 5th & Ocean Sales > Al Derago > Bobby Vann > T-SHIRT - SHORT SLEE > NBA PROPERTIES
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
756
|
756
|
Pass
|
2
|
Sales Org Currency
|
6,426
|
6,426.00
|
Pass
|
3
|
Corporate Currency
|
6,426
|
6,426.00
|
Pass
|
Group: Latin America Sales > Jim Grundtisch > Amado Gonzalez > 950 > NEW ERA BRANDED
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1
|
1
|
Pass
|
2
|
Sales Org Currency
|
14
|
14.25
|
Pass
|
3
|
Corporate Currency
|
14
|
14.25
|
Pass
|
Sixth Level Check
Test Conducted
Group: United State Sales > Darrell Debey > CPIHOUSE > 5950 > MLB PROPERTIES > BSN SPORTS INC
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
319
|
319
|
Pass
|
2
|
Sales Org Currency
|
3,806
|
3,805.53
|
Pass
|
3
|
Corporate Currency
|
3,806
|
3,805.53
|
Pass
|
Group: EMEA Sales > Giovanni Mantella > Ingesba SL > 4940 > NON LICENSED > INGESBA SL
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
8
|
8
|
Pass
|
2
|
Sales Org Currency
|
70
|
69.69
|
Pass
|
3
|
Corporate Currency
|
106
|
105.60
|
Pass
|
Dynamic Group 3:
Test Conducted
Dynamic Grouping Parameter(3) and Group Name: Sales Org > Sales Mangaer > Sales Rep > Customer > Style > License
Summary Level Check
Test Conducted
Group: Sales Orgs - Australia Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
34,889
|
34,889
|
Pass
|
2
|
Sales Org Currency
|
669,007
|
669,007.25
|
Pass
|
3
|
Corporate Currency
|
697,507
|
697,506.96
|
Pass
|
Group: Sales Orgs - NEC Korea sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
23,774
|
23,774
|
Pass
|
2
|
Sales Org Currency
|
455,054,104
|
455,054,104
|
Pass
|
3
|
Corporate Currency
|
409,549
|
409,548.69
|
Pass
|
Second Level Check
Test Conducted
Group: Canada Sales > Bill Adams
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
466
|
466
|
Pass
|
2
|
Sales Org Currency
|
1,779
|
1,778.97
|
Pass
|
3
|
Corporate Currency
|
1,751
|
1,750.51
|
Pass
|
Group: United States Sales > Kelly Burns
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
3,241,238
|
3,241,238
|
Pass
|
2
|
Sales Org Currency
|
29,019,068
|
29,019,068.41
|
Pass
|
3
|
Corporate Currency
|
29,019,068
|
29,019,068.41
|
Pass
|
Third Level Check
Test Conducted
Group: German Sales > Markus Fink > Jan Henning
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
2,583
|
2,583
|
Pass
|
2
|
Sales Org Currency
|
27,385
|
27,385.05
|
Pass
|
3
|
Corporate Currency
|
35,050
|
35,050.13
|
Pass
|
Group: Latin America Sales > Jim Grundtisch > Amado Gonzalez
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
770
|
770
|
Pass
|
2
|
Sales Org Currency
|
11,703
|
11,702.72
|
Pass
|
3
|
Corporate Currency
|
11,703
|
11,702.72
|
Pass
|
Fourth Level Check
Test Conducted
Group: Mexico Sales > David Perez > Alex Noguera > GRUPO GARDEA S A de CV
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
94,584
|
94,584
|
Pass
|
2
|
Sales Org Currency
|
17,686,296
|
17,686,296.18
|
Pass
|
3
|
Corporate Currency
|
1,432,590
|
1,432,589.99
|
Pass
|
Group: EMEA Sales > Ricky Sawyer > Cool by the Pool > Ozzys Ltd
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
90
|
90
|
Pass
|
2
|
Sales Org Currency
|
997
|
997.20
|
Pass
|
3
|
Corporate Currency
|
1,511
|
1,511.06
|
Pass
|
Fifth Level Check
Test Conducted
Group: 5th & Ocean Sales > Al Derago > Tim Tracy > J&J NOVELTY > FLEECE TOPS
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
38
|
38
|
Pass
|
2
|
Sales Org Currency
|
950
|
950.00
|
Pass
|
3
|
Corporate Currency
|
950
|
950.00
|
Pass
|
Group: Latin America Sales > Jim Grundtisch > Amado Gonzalez > MODA BLU > 950
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
30
|
30
|
Pass
|
2
|
Sales Org Currency
|
397
|
396.90
|
Pass
|
3
|
Corporate Currency
|
397
|
396.90
|
Pass
|
Sixth Level Check
Test Conducted
Group: United State Sales > John Lessieu > Bill Endicott > BOBS STORES > FLEECE TOPS > NFL PROPERTIES
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
930
|
930
|
Pass
|
2
|
Sales Org Currency
|
19,413
|
19,413.00
|
Pass
|
3
|
Corporate Currency
|
19,413
|
19,413.00
|
Pass
|
Group: EMEA Sales > Laurent Antoine > Bedivar > BEDIVAR > 3930 > MLB PROPERTIES
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
22
|
22
|
Pass
|
2
|
Sales Org Currency
|
127
|
126.96
|
Pass
|
3
|
Corporate Currency
|
192
|
192.40
|
Pass
|
Reference Document(Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports